﻿/* dk2Repository - Copyright (C) 2011 Daniel Kuczewski http://www.dk2.de/

 * This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA */

using System.Data;
using System.Data.Common;

namespace dk2Database
{

    /// <summary>
    /// Database class for SqLite connections
    /// </summary>
    public class SqLiteDatabase : Database
    {
        private readonly string _connectionstring;
        private readonly DbProviderFactory _providerFactory;

        public SqLiteDatabase(string file, string password)
        {
            _providerFactory = DbProviderFactories.GetFactory("System.Data.SQLite");

            if(!string.IsNullOrEmpty(password))
                _connectionstring = "Data Source=" + file + ";Version=3;Password=" + password + ";";
            else
                _connectionstring = "Data Source=" + file + ";Version=3;";
        }
        
        
        public SqLiteDatabase(string connectionstring)
        {
            _providerFactory = DbProviderFactories.GetFactory("System.Data.SQLite");
            _connectionstring = connectionstring;
        }

        protected override IDbConnection CreateDbConnection()
        {
            var con = _providerFactory.CreateConnection();
            con.ConnectionString = _connectionstring;

            return con;
        }
    }

}
